package zuoye;

import java.util.Scanner;

public class TestStudent {

	public static void main(String[] args) {
		Scanner input = new Scanner(System.in);

		IstudentDao s1 = new StudentDao();
		// 查询学生表内的全部信息

//		List<Student> list = s1.findAll();
//		for (Student s : list) {
//			System.out.println(s);
//		}

		// 增加

//		System.out.println("请输入姓名、电话号码、QQ号、微信号、城市、家庭地址、");
//		System.out.println("性别、关联到的年级编号、入学日期、生日、密码：");
//		String sname = input.next();
//		String telephone = input.next();
//		String qq = input.next();
//		String wechat = input.next();
//		String fromcity = input.next();
//		String address = input.next();
//		String sex = input.next();
//		int gradeid = input.nextInt();
//		String enterdate = input.next();
//		String birthday = input.next();
//		String pass = input.next();
//		Student s = new Student(sname, sex, telephone, qq, wechat, gradeid, enterdate, fromcity, birthday, address,
//				pass);
//		int num = s1.add(s);
//		System.out.println(num);
//
//		// 删除
//
//		System.out.println("请输入要删除的学号：");
//		int stuno = input.nextInt();
//		Student s = new Student(stuno);
//		int num1 = s1.del(s);
//		System.out.println(num1);

		// 修改

//		System.out.println("请输入学号、姓名、电话号码、QQ号、微信号、城市、家庭地址、");
//		System.out.println("性别、关联到的年级编号、入学日期、生日、密码：");
//		Long stuno = input.nextLong();
//		String sname = input.next();
//		String telephone = input.next();
//		String qq = input.next();
//		String wechat = input.next();
//		String fromcity = input.next();
//		String address = input.next();
//		String sex = input.next();
//		int gradeid = input.nextInt();
//		String enterdate = input.next();
//		String birthday = input.next();
//		String pass = input.next();
//		Student s = new Student(stuno, sname, sex, telephone, qq, wechat, gradeid, enterdate, fromcity, birthday,
//				address, pass);
//		int num = s1.update(s);
//		System.out.println(num);

		// 分页 统计

//		System.out.println("请输入页号和每页的条数：");
//		int pageNo = input.nextInt();
//		int pageSize = input.nextInt();
//
//		List<Student> list = s1.paging(pageNo, pageSize);
//		for (Student s : list) {
//			System.out.println(s);
//		}
//		System.out.println("总数为：" + s1.total());
	}
}